﻿CREATE TABLE [dbo].[RoutineParameter] (
    [Id]            INT            IDENTITY (1, 1) NOT NULL,
    [Name]          VARCHAR (50)   NOT NULL,
    [Value]         VARCHAR (1024) NULL,
    [ApplicationId] INT            NOT NULL,
    [RoutineId]     INT            NULL,
    FOREIGN KEY ([RoutineId]) REFERENCES [dbo].[Routine] ([Id]) ON DELETE NO ACTION ON UPDATE NO ACTION,
    FOREIGN KEY ([ApplicationId]) REFERENCES [dbo].[Application] ([Id]) ON DELETE NO ACTION ON UPDATE NO ACTION
);







